SQL Interview Questions and Answers
Test your skills through the online practice test: SQL Quiz Online Practice Test
Ques 36. Character Functions
Character Functions are INITCAP, UPPER, LOWER, SUBSTR & LENGTH. Additional functions are GREATEST & LEAST. Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN & SUM.
Is it helpful?
Add Comment
View Comments
Ques 37. TTITLE & BTITLE
TTITLE & BTITLE are commands to control report headings & footers.
Is it helpful?
Add Comment
View Comments
Ques 38. COLUMN
COLUMN command define column headings & format data values.
Is it helpful?
Add Comment
View Comments
Ques 39. BREAK
BREAK command clarify reports by suppressing repeated values, skipping lines & allowing for controlled break points.
Is it helpful?
Add Comment
View Comments
Ques 40. COMPUTE
command control computations on subsets created by the BREAK command.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: